CREATE TABLE [dbo].[AsiNrdsOffice]
(
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_ID] DEFAULT (''),
[AdditionalPhoneAreaCode] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_AdditionalPhoneAreaCode] DEFAULT (''),
[AdditionalPhoneNumber] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_AdditionalPhoneNumber] DEFAULT (''),
[AssociationId] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_AssociationId] DEFAULT (''),
[BillingOfficeId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_BillingOfficeId] DEFAULT (''),
[BranchType] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_BranchType] DEFAULT (''),
[BusinessName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_BusinessName] DEFAULT (''),
[ContactDRId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_ContactDRId] DEFAULT (''),
[ContactManagerId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_ContactManagerId] DEFAULT (''),
[ContactUnlicensed] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_ContactUnlicensed] DEFAULT (''),
[CorporateLicense] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_CorporateLicense] DEFAULT (''),
[CorporateName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_CorporateName] DEFAULT (''),
[District] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_District] DEFAULT (''),
[DRFirstName] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_DRFirstName] DEFAULT (''),
[DRLastName] [varchar] (17) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_DRLastName] DEFAULT (''),
[Email] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_Email] DEFAULT (''),
[FaxAreaCode] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_FaxAreaCode] DEFAULT (''),
[FaxNumber] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_FaxNumber] DEFAULT (''),
[FormalName] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_FormalName] DEFAULT (''),
[FranchiseId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_FranchiseId] DEFAULT (''),
[JoinedDate] [datetime] NULL,
[JunkMailFlag] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsOffice_JunkMailFlag] DEFAULT ((0)),
[MailAddressStreet1] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_MailAddressStreet1] DEFAULT (''),
[MailAddressStreet2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_MailAddressStreet2] DEFAULT (''),
[MailAddressCity] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_MailAddressCity] DEFAULT (''),
[MailAddressState] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_MailAddressState] DEFAULT (''),
[MailAddressZip] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_MailAddressZip] DEFAULT (''),
[MailAddressZip6] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_MailAddressZip6] DEFAULT (''),
[MainOfficeId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_MainOfficeId] DEFAULT (''),
[MlsId] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_MlsId] DEFAULT (''),
[MlsOnlineStatus] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_MlsOnlineStatus] DEFAULT (''),
[MlsOnlineStatusDate] [datetime] NULL,
[NMSalespersonCount] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_NMSalespersonCount] DEFAULT (''),
[OfficeId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_OfficeId] DEFAULT (''),
[OfficeType] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_OfficeType] DEFAULT (''),
[OnRosterFlag] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsOffice_OnRosterFlag] DEFAULT ((0)),
[ParentCompanyId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_ParentCompanyId] DEFAULT (''),
[PhoneAreaCode] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_PhoneAreaCode] DEFAULT (''),
[PhoneNumber] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_PhoneNumber] DEFAULT (''),
[PointOfEntry] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_PointOfEntry] DEFAULT (''),
[PrimaryIndicator] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_PrimaryIndicator] DEFAULT (''),
[PrimaryStateCode] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_PrimaryStateCode] DEFAULT (''),
[SortSequence] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_SortSequence] DEFAULT (''),
[Status] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_Status] DEFAULT (''),
[StatusDate] [datetime] NULL,
[StopFaxFlag] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsOffice_StopFaxFlag] DEFAULT ((0)),
[StopMailFlag] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsOffice_StopMailFlag] DEFAULT ((0)),
[StreetAddressStreet1] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_StreetAddressStreet1] DEFAULT (''),
[StreetAddressStreet2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_StreetAddressStreet2] DEFAULT (''),
[StreetAddressCity] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_StreetAddressCity] DEFAULT (''),
[StreetAddressState] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_StreetAddressState] DEFAULT (''),
[StreetAddressZip] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_StreetAddressZip] DEFAULT (''),
[StreetAddressZip6] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_StreetAddressZip6] DEFAULT (''),
[TaxId] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_TaxId] DEFAULT (''),
[Webpage] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_Webpage] DEFAULT (''),
[NARTimestamp] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsOffice_NARTimestamp] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[AsiNrdsOffice] ADD CONSTRAINT [PK_AsiNrdsOffice] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO